Query Solutions and Techniques for Database Developers

Query Solutions and Techniques for Database Developers

This book is ideal for software engineers, DW/ETL architects, and ETL developers who need to create a new, or enhance an existing, ETL implementation with SQL Server 2017 Integration Services. This book would also be good for individuals who develop ETL solutions that use SSIS and are keen to learn the new features and capabilities in SSIS 2017.

You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in several flavors of SQL,...(展开全部)

You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in several flavors of SQL,...(展开全部)

Why reinvent the wheel every time you run into a problem with JavaScript? This cookbook is chock-full of code recipes that address common programming tasks, as well as techniques for building web apps that work in any browser. Just copy and paste the code samples into your project -- you’ll get the job done faster and learn more about JavaScript in the process. You'll also l...(展开全部)

Why reinvent the wheel every time you run into a problem with JavaScript? This cookbook is chock-full of code recipes that address common programming tasks, as well as techniques for building web apps that work in any browser. Just copy and paste the code samples into your project -- you’ll get the job done faster and learn more about JavaScript in the process. You'll also l...(展开全部)

《SQL实战》是一本平易近人、节奏明快的SQL（Structured Query Language，结构化查询语言）指南。SQL是定义、组织和探索关系数据库中数据的标准程序设计语言。作为一名职业记者，安东尼·德巴罗斯专注于使用SQL寻找数据所讲述的故事。 本书首先会向你传授数据库和SQL语言的基础知识，然后通过分析诸如美国人口普查数据、纽约市出租车数据和全国农贸市场目录等现实世界的数据集来磨炼你的技能。通过本书每章展示的练习和示例，即使是编程新手也能够从中学到构建强大数据库和快速高效地访问信息所需的全部工具。 你将学会以下内容： - 使用你自有的数据创建数据库和表 - 聚合、排序和过滤数据以寻找模式 - 发现并纠正数据中的错误 - 为地理信息系统（GIS）编写查询 - 使用函数实施基本的数学运算以及高级的统计运算 - 创建高级查询和自动执行任务

Analyze data like a pro, even if you’re a beginner. Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. Anthony DeBarros, a journalist and data analyst, focuses on using SQL to find the story within your data. The examples and code use th...(展开全部)

"Perl Cookbook" is a comprehensive collection of problems, solutions, and practical examples for anyone programming in Perl. The book contains hundreds of rigorously reviewed Perl "recipes" and thousands of examples ranging from brief one-liners to complete applications. The second edition of Perl Cookbook has been fully updated for Perl 5.8, with extensive changes for Unicode ...(展开全部)